Model Table SALES QUOTATION LINE
This model fact represents information about sales quotations which is a pre-step of customer orders and is based on the IFS Cloud dimension FACT_SALES_QUOTATION_LINE. All models that refers to this fact will
have the attributes and hierarchies as described below.
Attributes
Attribute |
Description (where applicable) |
Additional Discount | An additional discount (%) which is added to the sales quotation and lines. |
Charged Item | A sales quotation line which should be invoiced. |
Charged Item Description | A sales quotation line which should be invoiced. |
Conversion Factor | The conversion factor between the sales unit of measure (UoM) and inventory UoM. |
Currency Rate | The currency rate used conversion between curr amount and amount. |
Demance Code | |
Demance Code Description | |
Discount | The line discount percentage. |
Group Discount | The discount percentage applicable to the sales part's discount group. |
Line Item Number | Line item number connected to sales quotation |
Line Number | The identity number of the sales quotation line. |
Lost To | If the quotation line was lost, this is the competitor who won the deal. |
Price Conversion Factor | The conversion factor used to convert the sales quantity expressed in sales unit of measure (UoM) to the quantity expressed in price UoM. |
Price List Number | The price list from which the prices are fetched for the quotation line. |
Probability To Win | The estimated probability to win the deal. |
Quotation Number | The identity number of the sales quotation. |
Rental | Indicates whether the order line is a rental line. |
Rental Description | Description of the rental line |
Sale Unit Price | The unit price. |
Sales Part Type | Indicates if the quotation line part is an inventory part or a non-inventory part. |
Sales Part Type Description | Indicates if the quotation line part is an inventory part or a non-inventory part. |
Sales Unite Measure | The sales unit of measure in which the part is sold, e.g., piece, meter, or kilo. |
State | The status of the quotation line. |
State Description | The status of the quotation line. |
Supply Code | The supply code specifies how a part should be supplied. |
Supply Code Description | The supply code specifies how a part should be supplied. |
Tax Code | Tax code |
Tax Code Description | Tax code |
USED BY MODEL(S)
Data source Information
The data source for this object is defined using IFS Developer Tool. The data
source contains a number of transformations where the model reads data from the
last step, i.e. the Data source view name (DW Source View Name).
Model Table |
DW Source view (SQL Server) |
BI Access View |
Referenced Information Source |
Recommended Access Type |
SALES QUOTATION LINE | FACT_SALES_QUOTATION_LINE_TM | FACT_SALES_QUOTATION_LINE_BI | FACT_SALES_QUOTATION_LINE | Data Mart |